SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 45236: #VALUE! is displayed in cells of a SAS® Financial Management CDA report

DetailsAboutRate It

If the regional option for a list separator has been changed from the default, cells in a SAS® Financial Management CDA report might display #VALUE!. This error occurs when using Microsoft Excel 2010.

A fix for this issue is included in a Security Update for Microsoft Excel 2010 [KB2553070].



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Financial ManagementMicrosoft® Windows® for x645.25.39.2 TS2M39.3 TS1M0
Microsoft Windows Server 2003 Datacenter Edition5.25.39.2 TS2M39.3 TS1M0
Microsoft Windows Server 2003 Enterprise Edition5.25.39.2 TS2M39.3 TS1M0
Microsoft Windows Server 2003 Standard Edition5.25.39.2 TS2M39.3 TS1M0
Microsoft Windows Server 2003 for x645.25.39.2 TS2M39.3 TS1M0
Microsoft Windows Server 20085.25.39.2 TS2M39.3 TS1M0
Microsoft Windows Server 2008 for x645.25.39.2 TS2M39.3 TS1M0
Microsoft Windows XP Professional5.25.39.2 TS2M39.3 TS1M0
Windows 7 Enterprise 32 bit5.25.39.2 TS2M39.3 TS1M0
Windows 7 Enterprise x645.25.39.2 TS2M39.3 TS1M0
Windows 7 Home Premium 32 bit5.25.39.2 TS2M39.3 TS1M0
Windows 7 Home Premium x645.25.39.2 TS2M39.3 TS1M0
Windows 7 Professional 32 bit5.25.39.2 TS2M39.3 TS1M0
Windows 7 Professional x645.25.39.2 TS2M39.3 TS1M0
Windows 7 Ultimate 32 bit5.25.39.2 TS2M39.3 TS1M0
Windows 7 Ultimate x645.25.39.2 TS2M39.3 TS1M0
Windows Vista5.25.39.2 TS2M39.3 TS1M0
Windows Vista for x645.25.39.2 TS2M39.3 TS1M0
64-bit Enabled AIX5.25.39.2 TS2M39.3 TS1M0
64-bit Enabled Solaris5.25.39.2 TS2M39.3 TS1M0
Linux for x645.25.39.2 TS2M39.3 TS1M0
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.